﻿CREATE TABLE [dbo].[t_BankruptcyCase] (
    [SSN]                 VARCHAR (9)   NOT NULL,
    [CaseNumber]          VARCHAR (16)  NOT NULL,
    [Chapter]             INT           NOT NULL,
    [DatePulled]          DATETIME      NOT NULL,
    [Filed]               SMALLDATETIME NOT NULL,
    [Office]              VARCHAR (64)  NULL,
    [County]              VARCHAR (64)  NULL,
    [Terminated]          SMALLDATETIME NULL,
    [Fee]                 VARCHAR (64)  NULL,
    [Discharged]          SMALLDATETIME NULL,
    [Origin]              VARCHAR (64)  NULL,
    [Reopened]            SMALLDATETIME NULL,
    [PreviousTerm]        VARCHAR (64)  NULL,
    [Converted]           SMALLDATETIME NULL,
    [Dismissed]           SMALLDATETIME NULL,
    [Joint]               VARCHAR (64)  NULL,
    [ConfirmationHearing] SMALLDATETIME NULL,
    [Disposition]         VARCHAR (512) NULL,
    [NatureOfDebt]        VARCHAR (64)  NULL,
    [PendingStatus]       VARCHAR (512) NULL,
    [Flags]               VARCHAR (512) NULL,
    [Trustee]             VARCHAR (64)  NULL,
    [City]                VARCHAR (64)  NULL,
    [Phone]               VARCHAR (64)  NULL,
    [Email]               VARCHAR (512) NULL
);

